How to: Delete a row from a worksheet.
Solution:
Click on any cell in the row, select 'Delete...' from 'Edit' menu, and choose 'Entire Row' radio button.
1) Click on any cell of the row to be deleted.
2) Select the 'Edit' menu and select 'Delete...'. (The Delete dialog box appears.)
3) Select the 'Entire Row' radio button.
4) Click 'OK'.
SHORTCUT: Click on the reference for the row to be deleted. Click on the right mouse button and select 'Delete' from the shortcut menu.
NOTE: To delete multiple rows, highlight the desired number of rows in the worksheet and follow steps 2) through 4) above.